

UPDATE FLW_PAL_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.1.12 (192.168.1.12)', LOCKGRANTED = to_timestamp('2020-04-27 14:23:48.311', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_PAL_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;



UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.1.12 (192.168.1.12)', LOCKGRANTED = to_timestamp('2020-04-27 14:23:49.921', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;



UPDATE ACT_DE_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.1.12 (192.168.1.12)', LOCKGRANTED = to_timestamp('2020-04-27 14:23:50.811', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;

ALTER TABLE ACT_DE_MODEL_RELATION ADD model_key VARCHAR2(255);

ALTER TABLE ACT_DE_MODEL_RELATION ADD tenant_id VARCHAR2(255);

ALTER TABLE ACT_DE_MODEL_RELATION ADD model_type INTEGER;

INSERT INTO ACT_DE_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('10', 'flowable', 'META-INF/liquibase/flowable-modeler-app-db-changelog.xml', SYSTIMESTAMP, 9, '7:87ed718332dae70d8ee3f7c24de8d728', 'addColumn tableName=ACT_DE_MODEL_RELATION', '', 'EXECUTED', NULL, NULL, '3.5.3', '7997431174');

UPDATE ACT_DE_MODEL_RELATION RELATION
            SET model_key = (SELECT MODEL.model_key FROM ACT_DE_MODEL MODEL WHERE MODEL.id = RELATION.model_id),
            model_type = (SELECT MODEL.model_type FROM ACT_DE_MODEL MODEL WHERE MODEL.id = RELATION.model_id);

UPDATE ACT_DE_MODEL_RELATION RELATION
            SET tenant_id = (SELECT MODEL.tenant_id FROM ACT_DE_MODEL MODEL WHERE MODEL.id = RELATION.app_model_id)
            WHERE RELATION.app_model_id is not null AND RELATION.app_model_id != 'none';

UPDATE ACT_DE_MODEL_RELATION RELATION
            SET tenant_id = (SELECT MODEL.tenant_id FROM ACT_DE_MODEL MODEL WHERE MODEL.id = RELATION.parent_model_id)
            WHERE RELATION.app_model_id is null OR RELATION.app_model_id = 'none';

INSERT INTO ACT_DE_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('11', 'flowable', 'META-INF/liquibase/flowable-modeler-app-db-changelog.xml', SYSTIMESTAMP, 10, '7:eb831db37f04883a882e10ab9cca39ea', 'sql; sql; sql', '', 'EXECUTED', NULL, NULL, '3.5.3', '7997431174');

ALTER TABLE ACT_DE_MODEL ADD tag VARCHAR2(400);

ALTER TABLE ACT_DE_MODEL_HISTORY ADD tag VARCHAR2(400);

CREATE TABLE ACT_DE_MODEL_TAG (id VARCHAR2(255) NOT NULL, name VARCHAR2(400) NOT NULL, tenant_id VARCHAR2(255) NOT NULL, CONSTRAINT PK_ACT_DE_MODEL_TAG PRIMARY KEY (id));

INSERT INTO ACT_DE_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('12', 'flowable', 'META-INF/liquibase/flowable-modeler-app-db-changelog.xml', SYSTIMESTAMP, 11, '7:b46f36f19648aac3105ba265702600b2', 'addColumn tableName=ACT_DE_MODEL; addColumn tableName=ACT_DE_MODEL_HISTORY; createTable tableName=ACT_DE_MODEL_TAG', '', 'EXECUTED', NULL, NULL, '3.5.3', '7997431174');

UPDATE ACT_DE_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

